if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Varietys]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Varietys]
GO

CREATE TABLE [dbo].[Varietys] (
	[VarietyID] [smallint] IDENTITY (1, 1) NOT NULL ,
	[VarietyCode] [smallint] NOT NULL ,
	[VarietyName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[VarietyNameUrdu] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ItemID] [smallint] NOT NULL ,
	[Active] [bit] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Varietys] WITH NOCHECK ADD 
	CONSTRAINT [PK_Varietys] PRIMARY KEY  CLUSTERED 
	(
		[VarietyID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Varietys] ADD 
	CONSTRAINT [DF_Varietys_Active] DEFAULT (0) FOR [Active]
GO